[client]
port=3306
socket=/tmp/mysql.sock
default-character-set=utf8
#user=root
##password=123

[mysqld]
server-id=1
skip-grant-tables
port=3306
user=mysql
max_connections=200
socket=/tmp/mysql.sock
basedir={{ mysql_dir }}
datadir={{ mysql_data_dir }}
pid-file={{ mysql_data_dir }}/mysql.pid
init-connect='SET NAMES utf8'
character-set-server=utf8
default-storage-engine=INNODB
log_error={{ mysql_data_dir }}/mysql-error.log
slow_query_log_file={{ mysql_data_dir }}/mysql-slow.log
long_query_time=2
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqldump]
quick
max_allowed_packet=16M
